Split multiple rows into mutliple columns along with its data.

[A_1997]

Hi Team,

I have a data received like below (Example: Before Table) and i need to rearrange the file in a different order (Example: After Table). Please help me to solve this and kindly note that we cannot filter each filename and arrange the files in the below mentioned order since there may have more than 10 'FileNames' in a data.

Before:

FileName	Product	Amount
ABC	Soap	$230
DEF	Chocolate	$450
GHI	Shampoo	$300

After:

FileName	Product	Amount		FileName	Product	Amount		FileName	Product	Amount
ABC	Soap	$230		DEF	Chocolate	$450		GHI	Shampoo	$300

[griffinwelsh]

Alteryx doesn't like columns with the same name, but this is the structure you are looking for. If you are writing to a spreadsheet we can make the duplicate column names in the output using a batch macro.

[griffinwelsh · Accepted solution]

If you want to output to excel with duplicate column names and null names for separating columns this solution will work as well.

[A_1997]

Hi @griffinwelsh

Thank you for the solution. This iterative Macro works on my project. :)