# What to use the Append or Merge Data step for
This step merges data by appending one set to another, either horizontally to merge rows or vertically to add columns from the second set to the end of the first. It's commonly used to append a webpage's URL to 'scraped data.'
You can use this step to:
- Combine Google Sheet data with scraped data
- Merge scarped data to a CSV
- Join two sets of scraped data
If you are looking to join different data sources based on matching columns try this step.
# How to configure the Append or Merge Data step
If you need to combine more than two columns of data use multiple Append data steps. You can also select Append steps inside of Append steps.
# Data A
Select the Data to be appended to (For example, data from a Google Sheet.) When selecting data, click on the token to see a preview. Click 'Save and close' to select all or click 'Clear All' to choose columns individually.
# Data B
Select the Data to be appended (For example, data from the Get data step.) When selecting data, click on the token to see a preview. Click 'Save and close' to select all or click 'Clear All' to choose columns individually.
# Append mode
Choose to append the data horizontally or vertically. Axiom.ai's data is formatted in a 2d array, so we commonly use the horizontal method which adds a column to the end of the array.
A preview of the appended data, so you can decide how you want to add it.