Excel question

Good question. I assume it’s a lot of columns.

You could write a simple macro to write the contents of each column to every other column. Just use separate counters for each.

You could also set up formula based columns on a 3rd sheet. Number across the top, Row1 = Col+0.5. If (Row1=Whole Number, Sheet1(Col),Sheet2(Col)).

I’m not at a computer to give you context, but that should be fairly easy to execute. You can then copy/paste values to get rid of the formulas.

Add a column in Spreadsheet A.

Then start at 1 and fill series to the bottom. Copy that range and paste it after the last value (first blank row). Then sort by column A descending.

Copy and paste the data without column A.

quote:

---

I would just copy the data to a text editor, replace a single hard return with two hard returns, then paste back into excel.

---

This. Notepad is still useful occasionally ...

Can you automate replacing a single return with two in Notepad? By using Notepad, when he pastes the data, will it overwrite the information on every other cell to blank?

OP, what does each spreadsheet look like? Do you need to write each line individually? Can you paste large blocks over the other data? Is the alternating data only located in Col A, or is it more expansive?

My first response assumed you had multiple columns of data from two sheets, that you needed to paste in an alternating fashion. Reading it again, it appears you just have one column you need to paste on alternating lines, between existing data with a blank row.

Insert a column to the left of your data, this'll make your data column B. In column A type 1, 3, 5, 7 in the first four rows. This should be the set of data in column A: A1 = 1, A2 = 3, A4 = 7. Now select the four entries and use the grabber at the bottom of the fourth cell to copy down the entire length of your data set in column B. Now in your second spreadsheet you'll type 1, 2, 3, 4 in the first four cells of column A: A1 = 1, A2 = 2, A3 = 3, A4 = 4. Now copy that down the entire sheet in sequence.

Now the fun part, in your second spreadsheet in cell B1 type this: =ISNA(VLOOKUP(A1,[SPREADSHEET1]SHEET1!A:B,2,FALSE),"") but replace "SPREADSHEET1" and "SHEET1" with the actual name of your first spreadsheet and the sheet with all your data. Once you've got this formula working fill it all the way down your sheet and you'll have the information from the first spreadsheet on every other line with empty cells between. You can now select column B in your second spreadsheet and copy + paste values. Once you're satisfied with the results you can delete column A, making column B the new column A. Also don't forget to undo the changes we made to the first spreadsheet after pasting values.

ETA: Just realized this question was from yesterday. Oh well.

quote:

---

Add a column in Spreadsheet A.

Then start at 1 and fill series to the bottom. Copy that range and paste it after the last value (first blank row). Then sort by column A descending.

Copy and paste the data without column A.

---

This is what I wound up doing. Worked perfectly

ASAP utilities add on is super. I haven't used it in a while but it's pretty awesome.