Automatic Merging In Excel

K

KetanR

New Member
Joined
Feb 14, 2017
Messages
32
Hi Folks,

Iam creating an automation spreadsheet (GDoc) but iam now stuck with a small issue. I work with a salesforce tool and have created a report but when i copy directly from the tool but it does not get pasted properly.

I have pasted an example below for reference,

SALESFORCE (REPORT DATA) DATA TO BE COPIED

[TABLE="width: 801"]
<tbody>[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: center"]ID NO
[/TD]
[TD="align: center"]NAME
[/TD]
[TD="align: center"]SHIPMENT DETAILS
[/TD]
[TD="align: center"]CLIENT DETAILS
[/TD]
[TD="align: center"]NOTES
[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD="align: center"]10
[/TD]
[TD="align: center"]Vikky
[/TD]
[TD="align: center"]00-10
[/TD]
[TD="align: center"]VIKKY-VIKKY MAIK,AC-India
[/TD]
[TD="align: center"]Forms are yet to be filled & Consolidation to be done
[/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD="align: center"]11
[/TD]
[TD="align: center"]Ankit
[/TD]
[TD="align: center"]00-11
[/TD]
[TD="align: center"]ANKIT-ANKIT MAIK,AB-India
[/TD]
[TD="align: center"]Forms are yet to be filled
[/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD="align: center"]12
[/TD]
[TD="align: center"]Mike
[/TD]
[TD="align: center"]00-12
[/TD]
[TD="align: center"]MIKE-MIKE CAND,AD-India
[/TD]
[TD="align: center"]Forms are yet to be filled & Consolidation to be done
[/TD]
[/TR]
[TR]
[TD="align: center"]6
[/TD]
[TD="align: center"]13
[/TD]
[TD="align: center"]Jason
[/TD]
[TD="align: center"]00-13
[/TD]
[TD="align: center"]JASON-JASON BOURNE,SB-America
[/TD]
[TD="align: center"]Forms are yet to be filled
[/TD]
[/TR]
[TR]
[TD="align: center"]7
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"]Austin
[/TD]
[TD="align: center"]00-14
[/TD]
[TD="align: center"]AUSTIN-AUSTIN PAUL,SB-America
[/TD]
[TD="align: center"]Forms are yet to be filled & Consolidation to be done
[/TD]
[/TR]
[TR]
[TD="align: center"]8
[/TD]
[TD="align: center"]15
[/TD]
[TD="align: center"]Paul
[/TD]
[TD="align: center"]00-15
[/TD]
[TD="align: center"]PAUL-PAUL BLAKE,SB-America
[/TD]
[TD="align: center"]Consolidation to be done
[/TD]
[/TR]
[TR]
[TD="align: center"]9
[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"]Jake
[/TD]
[TD="align: center"]00-16
[/TD]
[TD="align: center"]JAKE-JAKE CHRIST,SB-America
[/TD]
[TD="align: center"]Consolidation to be done
[/TD]
[/TR]
</tbody>[/TABLE]

"PASTED DATA"

[TABLE="width: 812"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"]ID NO
[/TD]
[TD="align: center"]NAME
[/TD]
[TD="align: center"]SHIPMENT DETAILS
[/TD]
[TD="align: center"]CLIENT DETAILS
[/TD]
[TD="align: center"]NOTES
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: center"]10
[/TD]
[TD="align: center"]Vikky
[/TD]
[TD="align: center"]00-10
[/TD]
[TD="align: center"]VIKKY-VIKKY MAIK,AC-India
[/TD]
[TD="align: center"]Forms are yet to be filled.
[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Consolidation to be done
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD="align: center"]11
[/TD]
[TD="align: center"]Ankit
[/TD]
[TD="align: center"]00-11
[/TD]
[TD="align: center"]ANKIT-ANKIT MAIK,AB-India
[/TD]
[TD="align: center"]Forms are yet to be filled
[/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD="align: center"]12
[/TD]
[TD="align: center"]Mike
[/TD]
[TD="align: center"]00-12
[/TD]
[TD="align: center"]MIKE-MIKE CAND,AD-India
[/TD]
[TD="align: center"]Forms are yet to be filled.
[/TD]
[/TR]
[TR]
[TD="align: center"]6
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"] Consolidation to be done
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7
[/TD]
[TD="align: center"]13
[/TD]
[TD="align: center"]Jason
[/TD]
[TD="align: center"]00-13
[/TD]
[TD="align: center"]JASON-JASON BOURNE,SB-America
[/TD]
[TD="align: center"]Forms are yet to be filled
[/TD]
[/TR]
[TR]
[TD="align: center"]8
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"]Austin
[/TD]
[TD="align: center"]00-14
[/TD]
[TD="align: center"]AUSTIN-AUSTIN PAUL,SB-America
[/TD]
[TD="align: center"]Forms are yet to be filled.
[/TD]
[/TR]
[TR]
[TD="align: center"]9
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Consolidation to be done
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10
[/TD]
[TD="align: center"]15
[/TD]
[TD="align: center"]Paul
[/TD]
[TD="align: center"]00-15
[/TD]
[TD="align: center"]PAUL-PAUL BLAKE,SB-America
[/TD]
[TD="align: center"]Consolidation to be done
[/TD]
[/TR]
[TR]
[TD="align: center"]11
[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"]Jake
[/TD]
[TD="align: center"]00-16
[/TD]
[TD="align: center"]JAKE-JAKE CHRIST,SB-America
[/TD]
[TD="align: center"]Forms are yet to be filled.
[/TD]
[/TR]
[TR]
[TD="align: center"]12
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"] Consolidation to be done
[/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]


When i copy report data and paste just like the above referred "PASTED DATA", 2 notes in a cell divides, separates and gets pasted in two different cells one below the other but in different cells so my doubt is, is there any automated formula which will automatically merge both the details together in one cell just like the reported data immediately after i paste the data. So please try and help me with a formula to bring both the data's together in a same cell.

Thanks in advance.
 
Sort by date Sort by votes
I might be a bit of a fudge but the paste seems to be triggering on the "&" character as that is missing from the pasted data. Can you remove that from your original data source? Also why does the last entry (16 - Jake) have additional data "consolidation to be done" when that doesn't appear in the original?
 
Upvote 0
@miless2111s

Hey there, you might be right.

I should not have mentioned "&", Please ignore the last entry as i had created the sample data in a bit of hurry. Sorry for the confusion.

In Sales-force, notes are been updated in a text box one below the other separated it with a dot(.) because its two different actions.

For Ex,

screen-shot-2012-08-11-at-12-21-58-am.png


Inside the text box data's are entered like,

- Forms are yet to be filled
- Consolidation to be done

And when i copy after running a periodic report and do the paste it in Gdoc. Data gets pasted just like what you have seen, the pasted data.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top