Some excel help

[Razor88]

Hi guys.

I'm not very familiar with excel, so if this is trivial, please forgive me.

I have an excel column like this in Column A:

Bread
Milk
Cheese

Now I want to copy the contents of A to Column D but I want it to skip a line after each entry like this:

Bread

Milk

Cheese

Is there a way to do this using a cell formula?

 

[CamiKaze]

No, don't think so.

Why would you want to do that though?

 

[Razor88]

No, don't think so.

Why would you want to do that though?

I'm making shelf labels to help someone out.

So I wanted it to map the description from A1 to D1, then the price from B1 to D2 etc, so that it looks like this:

Blue Ribbon White
R12.50

So that they can just highlight the D column and print it.

 

[maumau]

I'm no expert but wouldn't transpose work?

Doesn't OP have a column of names and a column of prices?

 

[CamiKaze]

Hi guys.
Now I want to copy the contents of A to Column D but I want it to skip a line after each entry like this:

I thought that you wanted everything in column A to be copied to column D.
However, it seems like you want to transpose everything in column A.

Or what?

 

[Razor88]

I thought that you wanted everything in column A to be copied to column D.
However, it seems like you want to transpose everything in column A.

Or what?

Hi. I planned to copy everything from A(description) to D and skip a row so that I could put Price (B) in the empty row. Something like this:





Turns out that transpose works for my purposes though, so I'll probably use that.

 

[Necropolis]

This formula might do the trick for you:

=IF(MOD(ROW(),2)=0,INDIRECT("A"&(ROW()/2)),"")

Change the "A" in the INDIRECT function with whatever column your base values are in.

Edit:

This one is more like it:

=IF(MOD(ROW(),2)=0,INDIRECT("A"&(ROW()/2)), IF((ROW() -1) > 0,INDIRECT("B"&((ROW()-1)/2)),""))

And will include your prices underneath

 

[Razor88]

This formula might do the trick for you:

=IF(MOD(ROW(),2)=0,INDIRECT("A"&(ROW()/2)),"")

Change the "A" in the INDIRECT function with whatever column your base values are in.

Edit:

This one is more like it:

=IF(MOD(ROW(),2)=0,INDIRECT("A"&(ROW()/2)), IF((ROW() -1) > 0,INDIRECT("B"&((ROW()-1)/2)),""))

And will include your prices underneath

This is literally perfect, thanks

 

[pratlou]

Brown bread is R13? :?

 

[Razor88]

Brown bread is R13? :?

Made up the prices for the example lol.

 

[Nerfherder]

Insert pivot table.