Hi team,[*]
I searched the forum but did not find answer to my problem. forgive me if i have repeated a thread.
I am using libreoffice 6.2.2.2 on Ubuntu 19.04
I want to know how i can transpose data in a single column (as shown below)
(Column A)
Name1
Address 1
Telephone 1
(empty cell)
Name2
Address 2
Telephone 2
(empty cell)
Name3
Address 3
Telephone 3
(empty cell)
Name4
Address 4
Telephone 4
to multiple rows accordingly as shown below.(A new row after every empty cell or cells )
(Column B) | (Column C) | (Column D)
Name1 | Address 1 | Telephone 1
Name2 | Address 2 | Telephone 2
Name3 | Address 3 | Telephone 3
Name4 | Address 4 | Telephone 4
Thank you
prasanjith
urls are for your kind perusal
https://drive.google.com/open?id=1mxjqz ... aLwgnkECG1
https://drive.google.com/open?id=1oglPM ... eJEPdLYy3p