am trying to import data to Access. Exported excel file has following
layout

Account_1

Date, Amount
Date, Amount


Account_2

Date, Amount
Date, Amount


I would like to move the Account cell value to different position, see
below


Account_1, Date, Amount
Account_1, Date, Amount


Account_2, Date, Amount
Account_2, Date, Amount


Is there any way to create VBA code that could do this for me?


Thanks