Previous Topic Next Topic

Merge data from 3 columns into one cell

Closed
gmpartsgirl - Nov 2, 2011 at 08:09 AM
 Blocked Profile - Nov 3, 2011 at 01:18 AM
Hello,
I am trying to make bin labels for my parts dpt. I have a file with 3 columns but it's 2051 rows long. I need the data from the 3 columns to go in the first cell of each row. The data needs to be stacked like below in one cell, so I can print individual labels for each part number. I know I could copy and paste but for 2051 rows of data, it would take at least all day. 
 
Example: 
 
10340740  MOUNT  0.027 
 
10340740
MOUNT
0.027


Related:

1 response

Answer 1 / 1
Blocked Profile
Nov 3, 2011 at 01:18 AM
Greetings,

Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator
0