Transpose from Columns to Rows, unique number of columns

[Kelly Monnia]

Hi,

I am trying to convert some data I received into a table format so that I can do some pivot table reporting. Here is some sample data:

First name Last name Sku 1 Sku 2 Sku 3 Sku 4 Sku 5
John Smith 123456 987654 125487 123589
Joe Adams 123457 987654 125487
Mary Star 123458 987654 125487 123589 123456


First name Last name Sku
John Smith 123456
John Smith 987654
John Smith 125487
John Smith 123589
Joe Adams 123457
Joe Adams 987654
Joe Adams 125487
Mary Star 123458
Mary Star 987654
Mary Star 125487
Mary Star 123589
Mary Star 123456

The number of rows will vary based on the number of SKU's associated with each name. For example, John Smith has 4 SKU's, so I would like to transpose it to 4 rows. Joe Adams only has 3 and Mary Star has 5.

Thanks for your help.

 

[NARAYANK991]

Hi Kelly ,

Instead of posting this data , can you please upload a sample workbook ?

Narayan

 

[vrunda]

As said by Narayan Sir Pls upload ur workbook & sample answer what do u exactly want. If all ur data is in columnar form you can apply pivot table directly.