CONCATENATE multiple rows into one row excel

Closed
niupen
Posts
4
Registration date
Friday April 9, 2010
Status
Member
Last seen
April 9, 2010
- Apr 9, 2010 at 11:11 AM
niupen
Posts
4
Registration date
Friday April 9, 2010
Status
Member
Last seen
April 9, 2010
- Apr 9, 2010 at 02:18 PM
Please need help in macro,

I have thousands of data from .txt to .xls.

Example of data

value Description
gem-967869 CPT4\HCPCS Code 82331 cannot be present
CPT4\HCPCS Code
cannot be present with CPT4\HCPCS Code 81000 or 81015 for the same Service Date
************************************
GEN-2174 CPT4\HCPCS Code 82310 cannot be present with CPT4\HCPCS Code 82331 for the sam
e Service Date
*************************************************************************

GEN-2175 CPT4\HCPCS Code 82331 cannot be present with CPT4/HCPCS Code 82330 for the sam
e Service Date
*************************************************************************
I want to merge all description line which are in one cell.

I might need macro for that please some one help me. I do not need Row with ********** value.

4 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 9, 2010 at 11:17 AM
How can one say that a particular description is on multiple line. May be if you could post a sample file at some share site like https://authentification.site and post a link here, it would be easier to see how data looks like and what needs to bedone
0
niupen
Posts
4
Registration date
Friday April 9, 2010
Status
Member
Last seen
April 9, 2010

Apr 9, 2010 at 11:39 AM
Hi,

Particular discripiton is in different rows from database.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 9, 2010 at 01:57 PM
What I am trying to say is that what you pasted above in the example. I for one am not able to tell where is the data that needs to be combined and which data is to be left alone. That is one of the reasons I suggested that you upload to a shared site a book with sample data both as it would be and how it should be once the macro runs
0
niupen
Posts
4
Registration date
Friday April 9, 2010
Status
Member
Last seen
April 9, 2010

Apr 9, 2010 at 02:18 PM
Sorry I can not able to upload file right now as https://authentification.site is blocked at my work. I will go home and upload the file for information. Thank you for the approach I will upload a file after 4 hours.
0