Solved

How to take contents from a COLUMN of data and place as an array in a SINGLE CELL?

Posted on 2011-09-29
3
173 Views
Last Modified: 2012-05-12
Experts:

My data in Excel 2010 looks like this in a single column:

861.32,
861.22,
861.21,
860.5,
860.4,
860.2,
860.1,
860.0,
854.09,
854.06,
854.05,

I need it to be transposed INTO a SINGEL CELL and have it look like this:

861.32, 861.22, 861.21, 860.5, 860.4, 860.2, 860.1, 860.0, 854.09, 854.06, 854.05,

There are about 1300 codes in the list...FYI....

Thanks
0
Comment
Question by:MIKE
  • 2
3 Comments
 
LVL 33

Accepted Solution

by:
Norie earned 500 total points
Comment Utility
Assuming the data is in column A starting in A1.

Put this in B2:

=A1 & A2

and this in B3

=B2&A3

then copy down from B3.

You can quickly do that by double clicking the bottom right of the cell (B3).
0
 
LVL 17

Author Comment

by:MIKE
Comment Utility
This will work for what I'm trying to do....THANKS!
0
 
LVL 33

Expert Comment

by:Norie
Comment Utility
Were you looking for code?
Dim arrVals
Dim strVals

arrVals = Range("A1", Range("A" & Rows.Count).End(xlUp)).Value

strVals = Join(Application.Transpose(arrVals), "")

Range("B1") = strVals

Open in new window

By the way I just noticed there might be an extra comma at the end.

Do you want to keep that?
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now