Converting 5 Rows into 1 and repeat till last Row with dynamic Range selection

[Panki]

Hi ,

I want to convert 5 rows data set into 1 row till last record.

Note - 1. Range ( A1:F15 ) is only for example and it can change in the actual data ,Hence I required dynamic range selection to avoid manual changes in the range every time.

My Data

Output Required:-

 

[awoohaw]

You can easily unpivot your data using Power Query. It is available as an ADD-IN for excel 2010.

About Power Query in Excel - Microsoft Support

With Power Query, you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports.

support.microsoft.com

Additionally there is a forum for POWER query in the Mr. Excel FORUM.

Power Tools

Power BI, Power Pivot, Power Query (Get and Transform), Power View, and Power Map

www.mrexcel.com

There are many many you tube videos that can help you learn the tool.
Mr. Excel, ExcelIsFun, Leila Gharani, and MyOnlineTrainingHub are great YouTube channels for this.