Forum Discussion
Take a range and space it out into columns
No specific formula comes to my mind to do the spacing. The TRANSPOSE function can take the range and render it in columns rather than rows adjacent to the original or in another sheet.
=TRANSPOSE(C2:C224)
BUT, may I ask you why? Will you be filling in the blank columns once they're there?
I'm wondering if there might be a different way to accomplish whatever your long term goal is.
Most of us who use Excel a lot are resistant to designs that involve a lot of blank rows or columns....it's one thing to space things out for a printed report, but another to try to work with data that has lots of spaces.....
So that's why I ask what otherwise might sound like none of my business.
JennaSmith495 wrote: It is for a report that displays scientific data. The spacing is to have a section for each sample.
Help me understand: are the current cells (C2:C224) labels for the samples, dates, what?
In general, Excel tables work better when each ROW is a complete record unto itself. Most of the Excel functions that summarize, tabulate, etc., are perfectly fitted for series of records arrayed like that, in rows.
https://exceljet.net/excel-tables
- This first one I am working on is the site code but there are many cells where I'm looking to do the same thing for the sample date and same ID, etc. The point of this report is for it to be readable to the average client that might not have a ton of scientific knowledge. I'm not sure I have much wiggle room to change the format our scientist wants.
My experience with arrays of tables and an array of clients is that people respond to clarity, whether it's in rows, columns or separate pages. Even scientists appreciate clarity, and some are capable of changing previous convictions. [insert smiley face here]