Format Data to tabular structure in Excel - Power m Query - Excel

Question

Hi, 

As a newbie, I am struggling to get the below output in excel 2016.

Below is the Input table as  formatted (coming from a HTML ) in query editor

Column1	Column2	Column3
S.no
Stock
Price
Close
	1
	Company X
	100
	2
	CompanyY
	200
	250
	3
	etc..

Note there are random blank cells in second columns. Can I get the above table to get below out put.

S.NO	Stock	Price	Close
1	CompanyX	100
2	CompanyY	200	250
3	etc....

Answer 1

Hi, @Kiranbvsn

You can check this out: https://www.howtoexcel.org/power-query/the-complete-guide-to-power-query/