Santosh080
Board Regular
- Joined
- Jul 15, 2016
- Messages
- 73
- Office Version
- 2021
- Platform
- Windows
Hi
I am new to excel. so need some help in converting a row into multiple column.
I have a excel file with one column like this,
and i want the above data in below format,
Please help how can i do this easily.
Thanks
Santosh
I am new to excel. so need some help in converting a row into multiple column.
I have a excel file with one column like this,
AAA | 123 | KI98 | BBB | 435 | FG45 | CCC | 854 | DF34 |
and i want the above data in below format,
AAA | 123 | KI98 |
BBB | 435 | FG45 |
CCC | 854 | DF34 |
Please help how can i do this easily.
Thanks
Santosh