ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Link Data from several colums into a single one and sort (https://www.excelbanter.com/excel-discussion-misc-queries/257326-link-data-several-colums-into-single-one-sort.html)

Chimako

Link Data from several colums into a single one and sort
 
I want to link data from three columns into a seperate single one and sort
them all out. The data in the three columns is generated by formulas.

Dave Peterson

Link Data from several colums into a single one and sort
 
I'm not sure what that means, but maybe you could use a formula like:

=a1&"|"&b1&"|"&c1
and drag down

The | character should be a unique character (not used in your real data) that
separates each field.

Chimako wrote:

I want to link data from three columns into a seperate single one and sort
them all out. The data in the three columns is generated by formulas.


--

Dave Peterson


All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com