如何分叉数据并将两列合并为一列 [英] How to bifurcate the data and merge two columns in to one

问题描述

嗨朋友们，

我有一个 MsAccess文件，其中有表格，其中每个表格中都有列数，但我想要的是我有两列，将其命名为 refrence 和 refrence1 ，其中包含 1234-1-ABC-123 等数据参考和参考1列我想做的是



1st Thing是将所有refrence1数据合并到refrence



第二件事我希望数据 分为4部分为 1234 1 ABC 和 123 as 四列saperatly



所以这是我的问题我不是了解如何做到这一点是他们以任何方式完成这项任务让我知道...



数据目前是这样的<大> 1234-1-ABC-123单列



我想要的结果是 1234 1 ABC和四列中的123

Hi Friends,
I have an MsAccess File which has tables in it in which i have number of columns in each table but what i want is I have an 2 columns in it name it as refrence and refrence1 which contain data like 1234-1-ABC-123 in both refrence and refrence1 columns what i want to do is

1st Thing is to merge all the refrence1 data to refrence

2nd Thing is i want this data to be divided in to 4 parts as 1234 1 ABC and 123 as four columns saperatly

So this is my problem i am not getting any idea how to do it is their any way to do this task let me know...

Data Currently is like this 1234-1-ABC-123 in Single column

Result i want is 1234 1 ABC and 123 in four columns

推荐答案

这篇关于如何分叉数据并将两列合并为一列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！