Join Table

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?

Accepted answers

paulfound

Hi @Neffri

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

Paul

Neffri.yxmd

David-Carnes

@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.