Merging data from mulitiple rows with the same timestamp into a single row.

5pm a----b----c---- d---- e-----f---- g,h-------I,j----- k,m-----
5pm a----b---- c---- empty-empty-empty-empty-empty-empty
5pm empty-empty-empty----d----e---- f---- -empty-empty-empty
5pm empty-empty-empty-empty-empty-empty-----g --- i----k----
5pm empty-empty-empty-h-----j----m----empty-empty-empty
5:01pm
5:01pm



I will have to merge the data in all the different fields with

the same time-stamp from 4 different row to a single row, as

shown above( merge into the row that is in BOLD. ) is there any

solutions for that?

Hi Gracejo,

Welcome to the forum. Is it possible if you attached a workbook, it would be easier to understand!

Cheers
Lex

I have attached the example in the reply.
Thanks.

Hi Gracejo,

try this

Please Login or Register  to view this content.

Hi nilem,

I've tried the code but however, I received a compile error:Expected End Sub as shown in the image that i have attached.
I have tried adding another "End Sub" at the bottom of the whole code but i still receive the same compile error.

Hi Gracejo,
here is your file
please try again

Hey,
So sorry. i cant seem to open the file. not sure is it because of the format. my excel files are with extension "xlsx".

xlsm is an extension of Excel macro enabled files

Hi I managed to open up the file already. Thanks alot.

However, i don't quite understand the different lines in the codes.
As i'm suppose the implement the same function into another excel file with more columns.

could i ask for some explanations to the line of codes. or which lines do i have to focus on to edit in order to implement it to anotherexcel file with more columns and data.

i do have another question. if i have duplicate data with the same timestamp, what code should i add in to filter them out then merge the other columns into a single row as previously.

Macro does just that.
Just try it. Or attach an example file if it does not work.

I have tried your code to the excel book that i have but it doesn't work.

Attached is just one part of the whole data.

Also, I have tried the code on this sample program but it doesn't remove the duplicates.

I have added duplicate values to Column F. However, after clicking the button, it still shows all the duplication.

here you go

Hi,
Example-2.1 works perfectly and awesomely. Thanks
However, i have no idea why it does not work on my excel sheet. is it got to do with the different columns?

Attached is the another example of the my excel sheet. would appreciate some help.

oops. sorry. uploaded the wrong file. i will upload the file again in 5 mins.

Hi,
Example-2.1 works perfectly and awesomely. Thanks
However, i have no idea why it does not work on my excel sheet. is it got to do with the different columns?

Attached is the another example of the my excel sheet. would appreciate some help.

PS: this is the right file.

Your 'Time' column is the second column (in 'test2.xlsm')
So change this line in the code

Please Login or Register  to view this content.

Hi,

it's working for the merging already.
However, do you have any idea why the timestamp after going through the program will change into some random number in sheet 2 instead of remaining the same.

attached is the attachment of my file.

Hi gracejo,
just set the cell format as you need

Please Login or Register  to view this content.

wow. Thanks.
However, why do they become to be "######" in sheet 2?

i will have to click on "######" in order to see the date and time.

wow. Thanks.
However, why do they become to be "######" in sheet 2?

i will have to click on "######" in order to see the date and time.

I was hoping that you will choose the column width manually.
Okay, let's add one more line in the code

Please Login or Register  to view this content.

AWESOME AWESOME!!!
Thanks alot for your help!!!