Transform Rows to Columns

[Anonymous]

Hi team,

I'm looking for a help / suggestion to transform rows to columns.

Attached is the sample data set for reference purposes.

Input Source table:

Model No.	Type	Project	Category	Count	List	Units
Dynamic	Type1	PRJ1	Category1	25	2500	4.15
Dynamic	Type1	PRJ1	Category1	50	20	3.38
Dynamic	Type1	PRJ1	Category1	100	25	3.17
Dynamic	Type1	PRJ1	Category1	150	30	3.17
Dynamic	Type1	PRJ1	Category1		35	3.17
Dynamic	Type1	PRJ1	Category1	200	45	8.19
Dynamic	Type1	PRJ1	Category1	250	50	9.23

Output source:

Model No.	Type	Project	Category	Count1	List1	Units1	Count2	List2	Units2	Count1	List2	Units2	Count3	List3	Units3	Count4	List4	Units4	Count5	List5	Units5	Count6	List6	Units6
Dynamic	Type1	PRJ1	Category1	25	2500	4.15	50	20	3.38	100	25	3.17	150	30	3.17		35	3.17	200	45	8.19	250	50	9.23

Thanks in advance.

Kind regards,

Anand

https://1drv.ms/f/s!Aj7kf6Fnqc5SwmD-8Jv-HKxKd9N8

[Anonymous · Accepted solution]

Hi all,

I have found the solution for the question that I posted for help last evening. Hope this helps, how I achieved the desired results.

Regards,

A!

https://1drv.ms/f/s!Aj7kf6Fnqc5SwmD-8Jv-HKxKd9N8