Is there a way to stack data from multiple columns into one and sort by date?

Mathew Fibus

I am trying to plan when each part of the order is supposed to be made in the columns "XLS".

I have formatted the data below how I want it in the columns Customer to Inoculation Dates.

The data I want to format is from Customer (original) to Quantity 2

I am thinking INDEX and MATCH, but I am completely stumped. I have tried to find the solution online but had no luck

Best,

Mathew

Find more posts tagged with

Accepted answers

All comments

BullandKhmer

What do you want to do, not really clear from your description.

Paul Newcome

The easiest way to reformat the data on the right to match the data on the left is going to be manually.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.