YasserKhalil
07-22-2017, 10:41 PM
Hello everyone
In sheet1 I have some raw data that needs to be reformatted ..
In row1 to 5 there's no problem .. these rows will be kept as they are
After that specific string "Hello" will appear in the first column >> in this case the three following rows will be deleted
The most important part is that the next row of the string "Hello" would be moved to the next records (rows) till the string "Hello" be found again ...
I have attached in Sheet2 the desired output so as to be easier to get it
I need the output to be in sheet2 not in the same data sheet (Sheet1)
Note : the original data is about 10,000 rows so I am searching for faster way for this task
Thanks advanced for help
In sheet1 I have some raw data that needs to be reformatted ..
In row1 to 5 there's no problem .. these rows will be kept as they are
After that specific string "Hello" will appear in the first column >> in this case the three following rows will be deleted
The most important part is that the next row of the string "Hello" would be moved to the next records (rows) till the string "Hello" be found again ...
I have attached in Sheet2 the desired output so as to be easier to get it
I need the output to be in sheet2 not in the same data sheet (Sheet1)
Note : the original data is about 10,000 rows so I am searching for faster way for this task
Thanks advanced for help