Transpose with repeat

[deepak.kec]

Hi,

I have the data in the excel in the form mentioned below.

P212J762 ANR-HEADER ANR-DATA ANR-TRAILER
P212J329 ANR-HEADER ANR-DATA ANR-TRAILER KONTO4

i want it in the format mentioned below,
P212J762 ANR-HEADER
P212J762 ANR-DATA
P212J762 ANR-TRAILER
P212J329 ANR-HEADER
P212J329 ANR-DATA
P212J329 ANR-TRAILER
P212J329 KONTO4

I guess it can be done with the help of transpose but am not sure.

Please suggest if you guys have a solution.

Thanks to all for the help.

[DonkeyOte]

You could probably do this using the Consolidated PT approach... see attached, if you double click on the Grand Total Number of 9 you will get a transposed listing (you can subsequently delete any data you don't want/need quite easily).

[deepak.kec]

Thanks for your quick response.

[deepak.kec]

It would be a great help if you could provide me brief information to do it. Since i am not much familier with Pivot table and i have huge data.

The solution which you have proposed is working but data in sheet one is not changeable.

[DonkeyOte]

To recreate using the sample file do the following:

-> Delete existing sheet containing PT

-> Data
-> Pivot Table
-> Multiple Consoldiation Range
-> Next
-> I will create Page Fields
-> Next
-> Range (select all of your data - ie Sheet1!A1:E4 on example file)
-> Add
-> Finish

(the above instructions may vary slightly pending your XL version - this is not in your profile so can't be more exact)

[deepak.kec]

Hi,

I have the data in the excel in the form mentioned below.
P212J762 ANR-HEADER
P212J762 ANR-DATA
P212J762 ANR-TRAILER
P212J329 ANR-HEADER
P212J329 ANR-DATA
P212J329 ANR-TRAILER
P212J329 KONTO4

I want it in the format mentioned below,
P212J762 ANR-HEADER ANR-DATA ANR-TRAILER
P212J329 ANR-HEADER ANR-DATA ANR-TRAILER KONTO4

Please let me know if it is possible using Pivot table.