tranpose

Hello, I would like some help making the following Pivot table in a "power query". I have attached the final version of my file. Transpose is necessary, but due to too many titles, I couldn't. Picture of the table below. It will make the job much easier and simpler in a situation like the...

I am trying to transpose data after the trigger word 'SKIP' is read. Sheet 1 contains the raw data Sheet 2 contains how i'd prefer the data output. Here is the data Thanks.

Hey there. I'm new to macros and programming. I am trying to make this data <colgroup><col style="width:48pt" width="64" span="15"> </colgroup><tbody> device1 app1 app2 app3 app4 app5 app6 app7 app8 device2 app1 app2 app3...

Hi All, I have a sheet from a manufacturer that tells me which models get which rewards. It looks like this... <tbody> MODELS REWARD X1245, J4541, Y4154 $15 A1015, N1522 $20 </tbody> In order for me to use v-lookup (as I have thousands of line items), How to I transpose this so that...

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C D E F G </thead><tbody> 1 Movie Log-Line 2 The Dark Knight In the wake of an alien attack that has crippled most of the world, shock has turned to resolve as the survivors...

Hi all. I read this post by Bill Jelen explaining how to do this for a one record: Spreadsheets: The Vertical-Horizontal Flip In my case, I have a record containing 10 items arranged vertically in one column. The records repeat, so record two is rows 11-20 and so on. I can't figure out how to...