Join Table

[Neffri]

Hi all,

I have a table with that contains information for current and previous months.

I’d like to create a column which will be showing information for the previous month.

It’s only a draft, in my original table I have more columns.

Can you please help me?  I’d like to create my target table? Should I use self join – I’ve tried to do this but I didn’t receive the correct numbers?

 

[paulfound · Accepted solution]

Hi @Neffri

Think this will work for you. Let me know how you get on.

Paul

[vizAlter]

Hi @Neffri — It's good to attach sample/dummy data to know more about your Input file and desired output file, both? Attached snapshot is not clear.

[David-Carnes]

@Neffri 

The Multi-Row Formula might be your friend here.

Good luck!
David

[Neffri]

I've attached better sample file. 

[David-Carnes · Accepted solution]

@Neffri 
OK, that looks a little different, lol, but I think the Multi-Row Formula tool is your simplest option.  I'm not sure what you want your final output to be, so if the Multi-Row doesn't fulfill your dreams then @paulfound 's answer might fit the bill.