Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-05-2014, 01:12 AM
FromF FromF is offline Selecting values from different rows in a table and sort them in order in a single row Windows 7 64bit Selecting values from different rows in a table and sort them in order in a single row Office 2010 64bit
Novice
Selecting values from different rows in a table and sort them in order in a single row
 
Join Date: Sep 2014
Posts: 2
FromF is on a distinguished road
Question Selecting values from different rows in a table and sort them in order in a single row

Hi,



I want to use a formula, or set of formulas, for selecting values from a data table were the number of values differ between rows (see attachment). I do not want to cut and paste or use any commands as I need to make this a executable function.

For instance, 9 rows and 21 cols (as in attachment), in the first row i have 21 values, in the 2nd only 4 and in the 3rd I have 5 etc. I want to "merge" these values in order in a single row, i.e. from B2 to V2 (in this case) and then continue with B3 to E3, and B4 to F4 etc, all in a single new row.

So in the table I have a total of 103 values in 9 rows, i want to sort them in a single row, i.e. from e.g. B15 to CZ15 (I think it will be CZ).


Thanks!
Fredrik
Attached Files
File Type: xlsx My table.xlsx (10.1 KB, 12 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting values from different rows in a table and sort them in order in a single row Sum values within a single cell shabbaranks Excel 17 05-13-2014 06:47 PM
Trying to autofilter 8-10 rows of numbers to sort in a group Jack-P-Winner Excel 0 11-25-2013 10:55 PM
How to sort word text in alphabetic order . crossing Word 8 01-20-2012 09:51 AM
Outlook 2007 Contacts Sort Order bianson Outlook 2 01-27-2011 10:32 AM
list of documents come up in random order - any ideas how to sort this? tallscot49 Word 0 07-18-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft