Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Saturday, March 10, 2018
  0 Replies
  2.5K Visits
0
Votes
Undo
Hi Team,

Can you please help me a logic to transform the below mentioned data format:

Column A
1
AA
BB
CC
1
DD
EE
FF
GG
HH
1
DD
AA
UU
XX..

1 being a character to differentiate set of data.
XX being Usernames

I want the data to be in single cell for each set of data. Example
In B1 the data will be AA
BB
CC
In B2 the data will be DD EE FF GG(with alt+enter) ie new line but in single cell.

Please help its urgent, I have 9000+ usernames to collate.
There are no replies made for this post yet.