Thanks it is very much interested And helpful too

@CeliaAlvesSolveExcel

6 ай бұрын

You're very welcome. Glad that you enjoyed it.

Thank you for explaining this feature!

@CeliaAlvesSolveExcel

10 ай бұрын

You're very welcome! Thank you for watching.

Wonderful! That is exactly what I was looking for. Thank you.

@CeliaAlvesSolveExcel

Жыл бұрын

You're welcome, Maciej. Glad that it was helpful to you. :)

Hi Celia, Useful, practical and clearly explained as usual. A nice addition to out PQ tool kit you are giving us. Thanks again Andrew

@CeliaAlvesSolveExcel

2 жыл бұрын

Glad that you found the content useful, Andrew. Thank you.

Great Celia! Thanks for sharing. Thumbs up!!

@CeliaAlvesSolveExcel

2 жыл бұрын

Thank you! Cheers!

Excelent. Very good. Congratulations...

@CeliaAlvesSolveExcel

Жыл бұрын

Thank you for watching and your feedback, Joseano.

This video just made my year not just my day, though #i need to see how to use a column to make the column headers, I think you did one on yime saving in power query, but so chuffed. Still need to get around the pivot and unpivot not grasping it a 100%, but thank you so much, I got it to work on 500 xls files I want to extract info from and the put into columns.

@CeliaAlvesSolveExcel

Жыл бұрын

Very glad that it helped you, Andrew. Unpivoting can be tricky to learn. It requires practice to get used to the tricks.

@CeliaAlvesSolveExcel

Жыл бұрын

I have a live class on unpivoting techniques: kzread.infowZdK6JlQpgQ

This is brilliant! Thank you

@CeliaAlvesSolveExcel

2 жыл бұрын

Thank you, Anoop. :)

Great, thanks Celia saved my bacon with some stupidly laid out file

HI Celia, this is really useful thank you! What happens if you're stacked rows are UNEVEN? How would you account for inconsistent data?

@CeliaAlvesSolveExcel

3 ай бұрын

I would say you will have to find a way to identify what kind of data point appears in each row.

Thanks, could you also provide link to download spreadsheet used in this tutorial

@CeliaAlvesSolveExcel

3 ай бұрын

See the video description

Hi - I just did it for something....but without pivot - I did group By each record and transposed it.... Regards Saurabh

@CeliaAlvesSolveExcel

2 жыл бұрын

That's a good technique too! :)

A other good technique

@CeliaAlvesSolveExcel

2 жыл бұрын

Thank you, Gráinne

Thank you how would I do if I have multiple columns?

@CeliaAlvesSolveExcel

9 ай бұрын

Without seeing it, it is hard to say. Do those columns contain the same type of data?

@lavangrey7429

9 ай бұрын

@@CeliaAlvesSolveExcel there are three columns and every 7 rows a new set begins As an example on the first column of 7 First column has the following rows First name, middle name, last name, ID number,staring rate, department, area, shift; second column has the following rows Start time, end time, order number, manager, supervisor, name of company The third column Blue, red, orange, 3 green, purple, gold, black the out put is in html format or I\pdf format

@CeliaAlvesSolveExcel

9 ай бұрын

@@lavangrey7429 create a query (query 1, query 2, query 3) for each column to unstack the data and create the column headers for each field. At the end of each query, make sure to add an index column, so that each row has a number and that number coincides for the same record across the 3 queries. Then, merge query 1 with query 2 by the column index and then merge the result with query 3.

@lavangrey7429

9 ай бұрын

@@CeliaAlvesSolveExcel I will give it a try. Thank you

How can I unstack a column when the data is not consistent and is unique? I don’t have the same criteria every third row. Some data might need three columns to unstack and sometimes it might need ten columns. I’m stumped, please help.

@CeliaAlvesSolveExcel

6 ай бұрын

I would say that you need a way to identify what belongs to each block or, at least, where each block starts or ends.

Thanks, very useful But if number of rows are not equal Like first group have 3 line Second group have 4 line Third group have 3. Line How to this type of data could be handled