SQLite Forum

Unstack one column to multiple
Login
I have a dataset in a single column table as below;

Hardside Cabin Luggage Trolley Black
senator
View Product Details
N18602991A	KH132-20_BLK	
KH13220BLK
02
Days
04
Hrs
25
Mins
25
Sec
1
1
0


Hardside 4 Wheels Cabin Luggage Trolley Burgundy
senator
View Product Details
N42588980A	KH134-20_BGN	
KH13420BGN
02
Days
04
Hrs
25
Mins
25
Sec
1
1
0


Softside Cabin Luggage Trolley Purple
senator
View Product Details
N32139616A	LL051-20_PRP	
LL05120PRP
02
Days
09
Hrs
25
Mins
25
Sec
1
1
0


Each row represents a value of a column and 2 empty rows mean the row change. The number of fields for each record also varies.

How to unstack and reshape these data from one column to multiple columns and rows into a proper table?