vscode-transpose-columns-and-rows

VS Code Extension for swapping (transposing) columns and rows in tabular text

Features

This extension allows you to select a portion of text and, treating it as a table, swap columns for rows.

For example, if you're editing long tab-separated spreadsheet lines like this:

height	time	time_exp(s)	extra	ETF	% ETF done
9.4	01:01	3012	21.51%	19:16:11	10.30%
17.8	01:50	5348	23.41%	19:25:26	18.29%

You can use the "Transpose tab-separated table" command to turn them into nice columns like this:

height     	9.4     	17.8
time       	01:01   	01:50
time_exp(s)	3012    	5348
extra      	21.51%  	23.41%
ETF        	19:16:11	19:25:26
% ETF done 	10.30%  	18.29%

Four commands are available:

• Transpose tab-separated table - useful for text pasted from a spreadsheet
• Transpose table separated by spaces - useful if there are spaces between values, but no value has a space in it
• Transpose comma-separated table (ignoring double quotes) - useful for simple CSV data
• Transpose CSV table - this is for real CSV data, especially with values with commas or newlines in it

The output is aligned nicely.

Known Issues

I've just made this, but if you find issues, please report them on GitHub.

Release Notes

0.0.2

Initial release.